Projects in other industries

Power BI reports for a global Pharmaceutical company
Helped the client monitor the timeliness and completeness of product deliveries at a global scale, working with their Customer Analytics CoE, to implement OTIF related BI reports.

  • Redesigned the On-Time & Fill-Rate report calculations to accommodate different delivery dates, enhancing accuracy and flexibility in performance tracking.
  • Defined development specifications for Power BI and provided team guidance on DAX best practices, ensuring high-quality and efficient reporting as per client requirements.
  • Led the refactoring of Power BI and Snowflake models to address challenges posed by increased data volume, resulting in a 2.25x improvement in performance and a 2.15x reduction in capacity costs.

Power BI reports for a global Shipping Company
Matt helped the company manage the ship spares supply chain of various shipping companies globally, by designing & developing a set of Power BI reports with advanced UI features and row-level security to provide personalized information on shipments, costs, and ESG metrics. These tools enabled the client to convert raw data into insights, KPIs & market trends and had a profound impact on their business; as they allowed them to operate with emphasis on strategic adjustments and aim to higher efficiency, sustainability and cost savings.

3PL report sanitized 3PL report sanitized 3PL report sanitized

** The screenshots have been 'sanitized'(parts of the reports with sensitive information have been removed) and aproval for publication has been granted.

Power BI reporting packs and cloud data flows for a leading Greek Energy provider
Implemented analytical assets that help the client organization monitor the financial and operational performance of their e-mobility assets, as well as manage risks in the energy market.

  • Designed & developed Power BI reports to help monitor utilization, availability and revenue of e-vehicle charging stations, and provide insights on their comparative evolution across markets & partners.
  • Designed & developed Databricks PySpark notebooks and Delta tables, to transform source systems input; created the final data marts that populate the reports in Azure Synapse, through T-SQL transformations.
  • Designed & developed Azure Data Factory pipelines to orchestrate the ELT data flows and access the e-mobility platforms API's, in addition to risk management systems focused on the energy stock market.

Marketing Mix Modeling Software for a Marketing Analytics provider
Matt was a member of the team who designed and implemented the software to model weekly sales time series, incorporating pricing, advertising, promotional, seasonal and macroeconomic effects. The company's analysts used the software on a daily basis, to evaluate models from a marketing perspective, interpret the impact on sales of key drivers, and prepare recommendations for customers worldwide.